UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'czrlBNDboYloXP4oqhgLBhEZceJHETBEaLPI5JxehHI='
WHERE
key_id = '71a730c67f11b3698161fc21a2a25264667c690d112b826fce661d2c29a04b2a'
AND (
token = 'czrlBNDboYloXP4oqhgLBhEZceJHETBEaLPI5JxehHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)