UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7rMmQlK8bJkSVPaQHkflk8kqVc7oEZgnaiU/7y+SAjo='
WHERE
key_id = 'dcd7d4583760afd1f646563c8a7faf25d895f33f4fa70d0f0420acf09a39fddd'
AND (
token = '7rMmQlK8bJkSVPaQHkflk8kqVc7oEZgnaiU/7y+SAjo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)