UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lZyA1MEtRubO0Ie4XHpBB0BmSg99OYUmFPui87U/jTA='
WHERE
key_id = 'e38456966aa2ed5e8b4660cf4e4788b20c1dd65cd6b1be8d22a2d34d782d3290'
AND (
token = 'lZyA1MEtRubO0Ie4XHpBB0BmSg99OYUmFPui87U/jTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)