UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pKR/9UEaNk0KGd9ip2RV18qKDlSQjmxjfDzC98Jpado='
WHERE
key_id = 'c4261a37e69b6cb46bb5be64a536e59022638a51536e829fe70e16cffd08cfe7'
AND (
token = 'pKR/9UEaNk0KGd9ip2RV18qKDlSQjmxjfDzC98Jpado='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)