UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+kJcAF9LCpdklxTVWx4eVbRKT5USk9v8t4cXNwrpGTM='
WHERE
key_id = 'ca1ab1a3616a77321e253a40bcc6b87e159665139b95c71173b47f8eff205724'
AND (
token = '+kJcAF9LCpdklxTVWx4eVbRKT5USk9v8t4cXNwrpGTM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)