UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ibFeGu28YxRPnPzGSBU9In7VVzucbVvrha0cBvjLqr0='
WHERE
key_id = '647342bf1dc5866d0a7abc2d80ad81ab40b715db68cfa8bfbf47610ef5c053ea'
AND (
token = 'ibFeGu28YxRPnPzGSBU9In7VVzucbVvrha0cBvjLqr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)