UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '20+FRw3mM2p94dbf+gGNpLnhSAJdnVdVCO7x5xPPbaU='
WHERE
key_id = 'c65610dc74e5efc025dd36e1d8ff138c4f6079c4aca034e68541946e6f0814c7'
AND (
token = '20+FRw3mM2p94dbf+gGNpLnhSAJdnVdVCO7x5xPPbaU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)