UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6gxzaB6FkzE3nEADUalzogG4oNmeagKKUstFjp/sQws='
WHERE
key_id = 'ffdaaba1cff241c124cb3a00ef77c6e6fa7a88cf1fbb53de0f9e33605cd5568d'
AND (
token = '6gxzaB6FkzE3nEADUalzogG4oNmeagKKUstFjp/sQws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)