UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/hPXJ6i4hjcfovf/TJ1K4S3GGuGn238Y9xQ2bvZKpss='
WHERE
key_id = 'e7307db1283bdc17d3f342b248442570615185fb5a6bf8c92675d79a03ed528c'
AND (
token = '/hPXJ6i4hjcfovf/TJ1K4S3GGuGn238Y9xQ2bvZKpss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)