UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EXWa6PE9h3VHKOD9oXRGsc1WuKBUOgUp4TFb9An/CMU='
WHERE
key_id = '5381246798493ae5b02670c4dea1906e2f08e65dd193dc509ef046d7febb4792'
AND (
token = 'EXWa6PE9h3VHKOD9oXRGsc1WuKBUOgUp4TFb9An/CMU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)