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