UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4GAkyXevMlhnD7EY464393gFNyl6tITBPalEK6iH4To='
WHERE
key_id = 'eae0538539c2ffc4ace48a824d5f159d3fa79e6fbf4042c4a8cf69a25ea2d83e'
AND (
token = '4GAkyXevMlhnD7EY464393gFNyl6tITBPalEK6iH4To='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)