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