UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ds+7hr5fbtG7gJR+ij3pRREjEG8aBnh2EgD4Hf1dHl8='
WHERE
key_id = '0fd41576dc3c09c72e38f6fc2d4a7d950f92c9182d62048d198e9d28a456304c'
AND (
token = 'Ds+7hr5fbtG7gJR+ij3pRREjEG8aBnh2EgD4Hf1dHl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)