UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zDysTkCOCHfvuV7SI9VcuTzq9ISl0p46GFyNA9xy99M='
WHERE
key_id = '77b3de7bfeee83b757510029038bd3d4b8ecac3929de9e4e108267b2116c62b1'
AND (
token = 'zDysTkCOCHfvuV7SI9VcuTzq9ISl0p46GFyNA9xy99M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)