UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NesyvVBounmRjWkB4TD4BT3QXea+i9HPvkQNvhr5Fag='
WHERE
key_id = 'd65999b997ff7a4f377fb25b152c23349056bb8a045a7fdcd928b6f5ab31e0f9'
AND (
token = 'NesyvVBounmRjWkB4TD4BT3QXea+i9HPvkQNvhr5Fag='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)