UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YGqAOMiI6kxy1WMotKdxsgKBz/jtWLgfDYD2fLZbec='
WHERE
key_id = 'dccd64bc89971c181cb73d0b8e7e612c2aa7db9807ea21b117dc4c521be53cda'
AND (
token = '3YGqAOMiI6kxy1WMotKdxsgKBz/jtWLgfDYD2fLZbec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)