UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UqdyRfOaPP8AfZESVci57hXetRuDzPNgnW1N3M/nvpg='
WHERE
key_id = 'c293ce923259a5ae2344c74afaa9a5d0429f094cb068e8fa60ef29e323b68654'
AND (
token = 'UqdyRfOaPP8AfZESVci57hXetRuDzPNgnW1N3M/nvpg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)