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