UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N8frpIj3SQLOB1ipB/yAq8hnu3r7rYqrvCOzuS9kml0='
WHERE
key_id = '027bd28f12f712915b52c37a4a54989bbc849f792e0c7806d667af08810a7ca9'
AND (
token = 'N8frpIj3SQLOB1ipB/yAq8hnu3r7rYqrvCOzuS9kml0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)