UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fmwc0AAsCT9CcfetKZ5c5moNuDzmCc76Y0yxlcK/SsY='
WHERE
key_id = 'd2678e24dccbdc5fbcdd03be76167407bd8ca07fb52d59b00c7392e382346a00'
AND (
token = 'fmwc0AAsCT9CcfetKZ5c5moNuDzmCc76Y0yxlcK/SsY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)