UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bX+dNOPccWU5PrE5gE4sHhaPDKk3peYuZ7GQqEMsy6c='
WHERE
key_id = 'a2ce379d5dc80b581f93730d28794f5f787b011a818d1d8b91750ca20551ed88'
AND (
token = 'bX+dNOPccWU5PrE5gE4sHhaPDKk3peYuZ7GQqEMsy6c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)