UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i7krNJKJvnL34UNQoDaSil9twFDIrEIlb+6bKVsR3zw='
WHERE
key_id = 'b5247c641d03ddcb8dba387febde7a0b1a95d569798a7f8c800bd7d843d70e62'
AND (
token = 'i7krNJKJvnL34UNQoDaSil9twFDIrEIlb+6bKVsR3zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)