UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kLPVs0XSVqMp8aoLGUP0DCsPCOlWJeuc65QcorOv+ms='
WHERE
key_id = 'c7a7591de785ba2b2eac8b147ff02874ece81fdc4f86426751db3c2cd59b4a27'
AND (
token = 'kLPVs0XSVqMp8aoLGUP0DCsPCOlWJeuc65QcorOv+ms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)