UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bFpJjVQaA3bNJ4dpVtS2dBzQ9bT6SyJZ9dWsgYbgdNo='
WHERE
key_id = 'b9cad98bf67178bdfeea69b6f32df1d66df22275793c8f555e43a873339aeee3'
AND (
token = 'bFpJjVQaA3bNJ4dpVtS2dBzQ9bT6SyJZ9dWsgYbgdNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)