UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x06jC4WAPsHtWZlef5P0zuLg7mR5YzxhEQZ9pju2nPE='
WHERE
key_id = '80c6701538aaab67d242ee84eff8e7e6abcceaf7d92d688a4a75a92338f7ef77'
AND (
token = 'x06jC4WAPsHtWZlef5P0zuLg7mR5YzxhEQZ9pju2nPE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)