UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nQ9B0hfYMDwOdpjWZ5dWPMkoB4y1MyjI182sJ9oYO/k='
WHERE
key_id = '46e720db98798f4773480def15c3d4b29d77fbd39069bf8217bb1e59e2b2ca92'
AND (
token = 'nQ9B0hfYMDwOdpjWZ5dWPMkoB4y1MyjI182sJ9oYO/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)