UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'T4k8diPzKzf7JsDiTCNS+ACYfk2tTJLs0A4gMarHVM8='
WHERE
key_id = 'b7ac2b641002f29bac3c917329f3445423968d2027d4b0a0c5b08e380e52e6ee'
AND (
token = 'T4k8diPzKzf7JsDiTCNS+ACYfk2tTJLs0A4gMarHVM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)