UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ccAJdZsvkR6C0GuUGNyiDbkbm9p2xL5cmiwlnBKLiEk='
WHERE
key_id = 'c3f565af61c1343f51b735c8fccac2145ed1dd1ad4f117bc52189683495560e9'
AND (
token = 'ccAJdZsvkR6C0GuUGNyiDbkbm9p2xL5cmiwlnBKLiEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)