UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FoL7EuJDHDJjhL6qzYDL6FlPKxJL2k9ZBM8jEQ8KQRA='
WHERE
key_id = '7b7d7cfd4f66bb282e8157fd774c5a6211aaed6acf4d76e4c9f57479672e64e7'
AND (
token = 'FoL7EuJDHDJjhL6qzYDL6FlPKxJL2k9ZBM8jEQ8KQRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)