UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TJHdCdrMo+ayxxUiRZWG8+5UyewxOxoKobs7qoj5upo='
WHERE
key_id = 'b4303f089e5919b316109958fd96ebce625b1173f6e3f7792944ca634e28d14c'
AND (
token = 'TJHdCdrMo+ayxxUiRZWG8+5UyewxOxoKobs7qoj5upo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)