UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZYhzaqrHjfMrcde5N6u9N/uuWh/9NEYPBv36Pu0CYA4='
WHERE
key_id = '5912d58a875f04a107cab51723e15b3b5de4134ae18845e6811c0e715dd307e8'
AND (
token = 'ZYhzaqrHjfMrcde5N6u9N/uuWh/9NEYPBv36Pu0CYA4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)