UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OXKr0HVliLZ/4jlV7BoIoPRcroSPxtefE77wyncTXdg='
WHERE
key_id = '074e9cf8f68fc0ab6ebdc1b732172892aa07326304dc76029200fa46ad564890'
AND (
token = 'OXKr0HVliLZ/4jlV7BoIoPRcroSPxtefE77wyncTXdg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)