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