UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/G+/cctSqHLUY8Yojh1Z4ohiZLEJvhAO5lU/lJ/X3Ac='
WHERE
key_id = 'ae94292427b76fe825cafd9e6ff4639175dac047b776b7a1f04f3c28580a8694'
AND (
token = '/G+/cctSqHLUY8Yojh1Z4ohiZLEJvhAO5lU/lJ/X3Ac='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)