UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oYIhk0HUXM8RfGzPDx3A6azaV/ssh8jXEAoHnOmFlYs='
WHERE
key_id = '46a729abc7f3f7bfa6ba54283496223b501f20d41d36123dbf78f4901a50cc10'
AND (
token = 'oYIhk0HUXM8RfGzPDx3A6azaV/ssh8jXEAoHnOmFlYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)