UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8nSfgcDk5Xw0Z09Ba657osWufcSSIHogEER2xfVr0/U='
WHERE
key_id = 'd88fbb23f96d0a388bff3440d1f17ba6a189e439e54a0cf9e988b1fbb17e7045'
AND (
token = '8nSfgcDk5Xw0Z09Ba657osWufcSSIHogEER2xfVr0/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)