UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'afeFK0E1b/P+jRDRCgwbjZgQG/Ka0xgDFLY/slI/F8k='
WHERE
key_id = 'e57278485175caa56ce70a99f8d333d6ef6a98901beb1b6c290437ae06cf793d'
AND (
token = 'afeFK0E1b/P+jRDRCgwbjZgQG/Ka0xgDFLY/slI/F8k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)