UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4LAfzaZsrK7hVeS3NVESgGsCjyeSZAnx5cNUrqbVegI='
WHERE
key_id = 'd5172e991b90362ea996dd2ffb7f433485a11fab7d42171915c79d137ecd2911'
AND (
token = '4LAfzaZsrK7hVeS3NVESgGsCjyeSZAnx5cNUrqbVegI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)