UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9wPkCE7/xxNlzYMJ9v3krzI+QFQ30Z68PuCT9XVy6dY='
WHERE
key_id = 'e77c9e9913b033982593e0d808871fd63be436fea138014a5b59d9e27272a113'
AND (
token = '9wPkCE7/xxNlzYMJ9v3krzI+QFQ30Z68PuCT9XVy6dY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)