UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+jxr6E496c5Ffy+wqTJ7NdFFUXapWvNwiIpua8qLV4s='
WHERE
key_id = '481b18eb34e7c42617fca276e0aa783f7595c1a5801511ee682b6cc22343d827'
AND (
token = '+jxr6E496c5Ffy+wqTJ7NdFFUXapWvNwiIpua8qLV4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)