UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0fCvfb4PHa6OVL3061TZcR8Sv7dDmMF0U1ytIiSBRIo='
WHERE
key_id = '78f3ddaf8abd53bf0a2e9e13d61130419913d93cf15e11a472d9c2a366cfd334'
AND (
token = '0fCvfb4PHa6OVL3061TZcR8Sv7dDmMF0U1ytIiSBRIo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)