UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xg465hgmzScSK4MvH+fFBulOSXVFq5kh0RP8A17MVJE='
WHERE
key_id = 'e0af6472dc5f26579151804c61c93fd8935ac6794139586ab72b0d24ee55f309'
AND (
token = 'xg465hgmzScSK4MvH+fFBulOSXVFq5kh0RP8A17MVJE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)