UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hCg/We4VKVK04hzabw5V0I6ci48yFfiKG5TjMymNkWM='
WHERE
key_id = '0d9bd7a359ec1a66a35420fcff46bc4c1a1efff33032e9fd0bd043f4002fe950'
AND (
token = 'hCg/We4VKVK04hzabw5V0I6ci48yFfiKG5TjMymNkWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)