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